<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  

  
  <title>Excel 2013 – 新增函数 | 一起学Excel</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta name="description" content="日期和时间函数DAYS 函数DAYS 函数返回两个日期之间的天数。 12&#x3D;DAYS(end_date, start_date)&#x3D;DAYS(结束日期, 开始日期)  ISOWEEKNUM 函数ISOWEEKNUM函数返回指定日期在全年中的 ISO 周数。ISO周日历系统是ISO 8601日期和时间标准的一部分，是一种闰周历系统。 12&#x3D;ISOWEEKNUM(date)&#x3D;ISOWEEKNUM(日期)">
<meta property="og:type" content="article">
<meta property="og:title" content="Excel 2013 – 新增函数">
<meta property="og:url" content="https://lecoder.gitee.io/study-excel/excel-2013-new-functions/index.html">
<meta property="og:site_name" content="一起学Excel">
<meta property="og:description" content="日期和时间函数DAYS 函数DAYS 函数返回两个日期之间的天数。 12&#x3D;DAYS(end_date, start_date)&#x3D;DAYS(结束日期, 开始日期)  ISOWEEKNUM 函数ISOWEEKNUM函数返回指定日期在全年中的 ISO 周数。ISO周日历系统是ISO 8601日期和时间标准的一部分，是一种闰周历系统。 12&#x3D;ISOWEEKNUM(date)&#x3D;ISOWEEKNUM(日期)">
<meta property="og:locale" content="zh_CN">
<meta property="article:published_time" content="2022-11-23T07:04:54.084Z">
<meta property="article:modified_time" content="2022-11-23T08:14:32.939Z">
<meta property="article:author" content="lijile">
<meta name="twitter:card" content="summary">
  
  
    <link rel="icon" href="/favicon.png">
  
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  
  
<link rel="stylesheet" href="/study-excel/css/style.css">

<meta name="generator" content="Hexo 6.3.0"></head>

<body>
  <div id="container">
    <div id="wrap">
      <header id="header">
  <div id="banner"></div>
  <div id="header-outer" class="outer">
    <div id="header-title" class="inner">
      <h1 id="logo-wrap">
        <a href="/study-excel/" id="logo">一起学Excel</a>
      </h1>
      
    </div>
    <div id="header-inner" class="inner">
      <nav id="main-nav">
        <a id="main-nav-toggle" class="nav-icon"></a>
        
          <a class="main-nav-link" href="/study-excel/">Home</a>
        
          <a class="main-nav-link" href="/study-excel/archives">Archives</a>
        
      </nav>
      <nav id="sub-nav">
        
        <a id="nav-search-btn" class="nav-icon" title="搜索"></a>
      </nav>
      <div id="search-form-wrap">
        <form action="//google.com/search" method="get" accept-charset="UTF-8" class="search-form"><input type="search" name="q" class="search-form-input" placeholder="Search"><button type="submit" class="search-form-submit">&#xF002;</button><input type="hidden" name="sitesearch" value="https://lecoder.gitee.io/study-excel"></form>
      </div>
    </div>
  </div>
</header>
      <div class="outer">
        <section id="main"><article id="post-excel-2013-new-functions" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2013-new-functions/" class="article-date">
  <time datetime="2022-11-23T07:04:54.084Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 class="article-title" itemprop="name">
      Excel 2013 – 新增函数
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="日期和时间函数"><a href="#日期和时间函数" class="headerlink" title="日期和时间函数"></a>日期和时间函数</h2><h3 id="DAYS-函数"><a href="#DAYS-函数" class="headerlink" title="DAYS 函数"></a>DAYS 函数</h3><p>DAYS 函数返回两个日期之间的天数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=DAYS(end_date, start_date)</span><br><span class="line">=DAYS(结束日期, 开始日期)</span><br></pre></td></tr></table></figure>

<h3 id="ISOWEEKNUM-函数"><a href="#ISOWEEKNUM-函数" class="headerlink" title="ISOWEEKNUM 函数"></a>ISOWEEKNUM 函数</h3><p>ISOWEEKNUM函数返回指定日期在全年中的 ISO 周数。ISO周日历系统是ISO 8601日期和时间标准的一部分，是一种闰周历系统。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ISOWEEKNUM(date)</span><br><span class="line">=ISOWEEKNUM(日期)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="工程函数"><a href="#工程函数" class="headerlink" title="工程函数"></a>工程函数</h2><h3 id="BITAND-函数"><a href="#BITAND-函数" class="headerlink" title="BITAND 函数"></a>BITAND 函数</h3><p>BITAND 函数返回两个数的按位进行“与”（AND）运算后的结果。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITAND( number1, number2)</span><br></pre></td></tr></table></figure>

<h3 id="BITLSHIFT-函数"><a href="#BITLSHIFT-函数" class="headerlink" title="BITLSHIFT 函数"></a>BITLSHIFT 函数</h3><p>BITLSHIFT 函数返回一个数向左移动指定位数后的数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITLSHIFT(number, shift_amount)</span><br></pre></td></tr></table></figure>

<h3 id="BITOR-函数"><a href="#BITOR-函数" class="headerlink" title="BITOR 函数"></a>BITOR 函数</h3><p>BITOR 函数返回两个数的按位进行“或”（OR）运算后的结果。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITOR( number1, number2)</span><br></pre></td></tr></table></figure>

<h3 id="BITRSHIFT-函数"><a href="#BITRSHIFT-函数" class="headerlink" title="BITRSHIFT 函数"></a>BITRSHIFT 函数</h3><p>BITRSHIFT 函数返回一个数向右移动指定位数后的数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITRSHIFT(number, shift_amount)</span><br></pre></td></tr></table></figure>

<h3 id="BITXOR-函数"><a href="#BITXOR-函数" class="headerlink" title="BITXOR 函数"></a>BITXOR 函数</h3><p>BITXOR 函数返回两个数的按位进行“异或”（XOR）运算后的结果。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITXOR( number1, number2)</span><br></pre></td></tr></table></figure>

<h3 id="IMCOSH-函数"><a href="#IMCOSH-函数" class="headerlink" title="IMCOSH 函数"></a>IMCOSH 函数</h3><p>IMCOSH 函数返回以 x + yi 或 x + yj 文本格式表示的复数的双曲余弦值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMCOSH(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMCOT-函数"><a href="#IMCOT-函数" class="headerlink" title="IMCOT 函数"></a>IMCOT 函数</h3><p>IMCOT 函数返回以 x + yi 或 x + yj 文本格式表示的复数的余切值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMCOT(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMCSC-函数"><a href="#IMCSC-函数" class="headerlink" title="IMCSC 函数"></a>IMCSC 函数</h3><p>IMCSC 函数返回以 x + yi 或 x + yj 文本格式表示的复数的余割值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMCSC(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMCSCH-函数"><a href="#IMCSCH-函数" class="headerlink" title="IMCSCH 函数"></a>IMCSCH 函数</h3><p>IMCSCH 函数返回以 x + yi 或 x + yj 文本格式表示的复数的双曲余割值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMCSCH(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMSEC-函数"><a href="#IMSEC-函数" class="headerlink" title="IMSEC 函数"></a>IMSEC 函数</h3><p>IMSEC 函数返回以 x + yi 或 x + yj 文本格式表示的复数的正割值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMSEC(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMSEH-函数"><a href="#IMSEH-函数" class="headerlink" title="IMSEH 函数"></a>IMSEH 函数</h3><p>IMSEH 函数返回以 x + yi 或 x + yj 文本格式表示的复数的双曲正割值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMSECH(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMSINH-函数"><a href="#IMSINH-函数" class="headerlink" title="IMSINH 函数"></a>IMSINH 函数</h3><p>IMSINH 函数返回以 x + yi 或 x + yj 文本格式表示的复数的双曲正弦值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMSINH(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMTAN-函数"><a href="#IMTAN-函数" class="headerlink" title="IMTAN 函数"></a>IMTAN 函数</h3><p>IMTAN 函数返回以 x + yi 或 x + yj 文本格式表示的复数的正切值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMTAN(inumber</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="财务函数"><a href="#财务函数" class="headerlink" title="财务函数"></a>财务函数</h2><h3 id="PDURATION-函数"><a href="#PDURATION-函数" class="headerlink" title="PDURATION 函数"></a>PDURATION 函数</h3><p>此函数为财务函数中计算持续期的函数，返回投资到达指定值所需的期数。函数名由Period（时期）+Duration（期间）两个单词组成。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=PDURATION(rate, pv, fv)</span><br><span class="line">=PDURATION(每期利率, 现值, 未来值)</span><br></pre></td></tr></table></figure>

<h3 id="RRI-函数"><a href="#RRI-函数" class="headerlink" title="RRI 函数"></a>RRI 函数</h3><p>此函数为财务函数中计算利息率值的函数，返回投资增长的等效利率。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=RRI(nper,pv, fv)</span><br><span class="line">=RRI(投资期数, 现值, 未来值)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="信息函数"><a href="#信息函数" class="headerlink" title="信息函数"></a>信息函数</h2><h3 id="ISFORMULA-函数"><a href="#ISFORMULA-函数" class="headerlink" title="ISFORMULA 函数"></a>ISFORMULA 函数</h3><p>ISFORMULA 函数检查指定的单元格是否包含公式。如果包含公式，则返回 TRUE；否则，返回 FALSE。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=ISFORMULA(reference )</span><br></pre></td></tr></table></figure>

<h3 id="SHEET-函数"><a href="#SHEET-函数" class="headerlink" title="SHEET 函数"></a>SHEET 函数</h3><p>SHEET 函数返回指定工作表的工作表编号。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=SHEET([value])</span><br></pre></td></tr></table></figure>

<h3 id="SHEETS-函数"><a href="#SHEETS-函数" class="headerlink" title="SHEETS 函数"></a>SHEETS 函数</h3><p>SHEETS 函数返回引用中的工作表数量。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=SHEETS(reference)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="逻辑函数"><a href="#逻辑函数" class="headerlink" title="逻辑函数"></a>逻辑函数</h2><h3 id="IFNA-函数"><a href="#IFNA-函数" class="headerlink" title="IFNA 函数"></a>IFNA 函数</h3><p>IFNA 函数判断提供的初始条件的结果是否返回 #N&#x2F;A 型错误，如果返回 #N&#x2F;A 型错误，则返回提供的第二个参数；否则返回初始条件或其计算结果。函数名由If（如果）+ #N&#x2F;A（Excel 的值不可用错误）等部分组成。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=IFNA(value, value_if_na)</span><br><span class="line">=IFNA(条件, 条件结果为#N/A型错误时的返回值)</span><br></pre></td></tr></table></figure>

<h3 id="XOR-函数"><a href="#XOR-函数" class="headerlink" title="XOR 函数"></a>XOR 函数</h3><p>XOR 函数返回提供的所有参数的异或逻辑运算值。函数名由 Exclusive（独家）+ Or（或者）等部分组成。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=XOR(logical1, [logical2],…)</span><br><span class="line">=XOR(逻辑值1, [逻辑值2],…)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="查找与引用函数"><a href="#查找与引用函数" class="headerlink" title="查找与引用函数"></a>查找与引用函数</h2><h3 id="FORMULATEXT-函数"><a href="#FORMULATEXT-函数" class="headerlink" title="FORMULATEXT 函数"></a>FORMULATEXT 函数</h3><p>FORMULATEXT 函数以文本格式返回指定单元格的公式。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FORMULATEXT(reference)</span><br><span class="line">=FORMULATEXT(单元格引用)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="数学与三角函数"><a href="#数学与三角函数" class="headerlink" title="数学与三角函数"></a>数学与三角函数</h2><h3 id="ACOT-函数"><a href="#ACOT-函数" class="headerlink" title="ACOT 函数"></a>ACOT 函数</h3><p>ACOT 函数返回数字的反余切值的主值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ACOT(number)</span><br><span class="line">=ACOT(数字)</span><br></pre></td></tr></table></figure>

<h3 id="ACOTH-函数"><a href="#ACOTH-函数" class="headerlink" title="ACOTH 函数"></a>ACOTH 函数</h3><p>ACOTH 函数返回数字的反双曲余切值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ACOTH(number)</span><br><span class="line">=ACOTH(数字)</span><br></pre></td></tr></table></figure>

<h3 id="ARABIC-函数"><a href="#ARABIC-函数" class="headerlink" title="ARABIC 函数"></a>ARABIC 函数</h3><p>ARABIC 函数将罗马数字转换为阿拉伯数字。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ARABIC(text)</span><br><span class="line">=ARABIC(字符串)</span><br></pre></td></tr></table></figure>

<h3 id="BASE-函数"><a href="#BASE-函数" class="headerlink" title="BASE 函数"></a>BASE 函数</h3><p>BASE 函数将数字转换为以指定基数（二进制、十六进制等）的数字，返回其文本表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=BASE(Number, Radix,[Min_length])</span><br><span class="line">=BASE(数字, 基数, [字符串最小长度])</span><br></pre></td></tr></table></figure>

<h3 id="CEILING-MATH-函数"><a href="#CEILING-MATH-函数" class="headerlink" title="CEILING.MATH 函数"></a>CEILING.MATH 函数</h3><p>CEILING.MATH 函数将数字向上舍入到整数或者以指定基数的倍数向上舍入。对于负数，可以控制舍入方向。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=CEILING.MATH(number,[significance],  [mode])</span><br><span class="line">=CEILING.MATH(数字, [舍入倍数], [方向])</span><br></pre></td></tr></table></figure>

<h3 id="COMBINA-函数"><a href="#COMBINA-函数" class="headerlink" title="COMBINA 函数"></a>COMBINA 函数</h3><p>COMBINA 函数返回指定数量元素的总组合数（包含重复项）。可以指定组合元素数量。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=COMBINA(number,number_chosen)</span><br><span class="line">=COMBINA(数量, 选中元素数量)</span><br></pre></td></tr></table></figure>

<h3 id="COT-函数"><a href="#COT-函数" class="headerlink" title="COT 函数"></a>COT 函数</h3><p>COT 函数返回角度的余切值，提供的角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=COT(number)</span><br><span class="line">=COT(角度)</span><br></pre></td></tr></table></figure>

<h3 id="COTH-函数"><a href="#COTH-函数" class="headerlink" title="COTH 函数"></a>COTH 函数</h3><p>COTH 函数返回角度的双曲余切值，提供的角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=COTH(number)</span><br><span class="line">=COTH(角度)</span><br></pre></td></tr></table></figure>

<h3 id="CSC-函数"><a href="#CSC-函数" class="headerlink" title="CSC 函数"></a>CSC 函数</h3><p>CSC 函数返回角度的余割值，角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=CSC(number)</span><br><span class="line">=CSC(角度)</span><br></pre></td></tr></table></figure>

<h3 id="CSCH-函数"><a href="#CSCH-函数" class="headerlink" title="CSCH 函数"></a>CSCH 函数</h3><p>CSCH 函数返回角度的双曲余割值，角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=CSCH(number)</span><br><span class="line">=CSCH(角度)</span><br></pre></td></tr></table></figure>

<h3 id="DECIMAL-函数"><a href="#DECIMAL-函数" class="headerlink" title="DECIMAL 函数"></a>DECIMAL 函数</h3><p>DECIMAL 函数将按指定基数表示的文本数字转换为十进制数字。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=DECIMAL(text, radix)</span><br><span class="line">=DECIMAL(文本格式数字, 基数)</span><br></pre></td></tr></table></figure>

<h3 id="FLOOR-MATH-函数"><a href="#FLOOR-MATH-函数" class="headerlink" title="FLOOR.MATH 函数"></a>FLOOR.MATH 函数</h3><p>FLOOR.MATH 函数将数字向下舍入（沿绝对值减小的方向）到最近的指定基数的倍数，可以指定负数舍入方向。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FLOOR.MATH( number, [significance], [mode] )</span><br><span class="line">=FLOOR.MATH( 数字, [倍数], [方向] )</span><br></pre></td></tr></table></figure>

<h3 id="MUNIT-函数"><a href="#MUNIT-函数" class="headerlink" title="MUNIT 函数"></a>MUNIT 函数</h3><p>MUNIT 函数返回指定维度的单位矩阵。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=MUNIT(dimension)</span><br><span class="line">=MUNIT(维度)</span><br></pre></td></tr></table></figure>

<h3 id="SEC-函数"><a href="#SEC-函数" class="headerlink" title="SEC 函数"></a>SEC 函数</h3><p>SEC 函数返回角度的正割值，提供的角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=SEC(number)</span><br><span class="line">=SEC(角度)</span><br></pre></td></tr></table></figure>

<h3 id="SECH-函数"><a href="#SECH-函数" class="headerlink" title="SECH 函数"></a>SECH 函数</h3><p>SECH 函数返回角度的双曲正割值，提供的角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=SECH(number)</span><br><span class="line">=SECH(角度)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="统计函数"><a href="#统计函数" class="headerlink" title="统计函数"></a>统计函数</h2><h3 id="BINOM-DIST-RANGE-函数"><a href="#BINOM-DIST-RANGE-函数" class="headerlink" title="BINOM.DIST.RANGE 函数"></a>BINOM.DIST.RANGE 函数</h3><p>BINOM.DIST.RANGE 函数使用二项式分布返回试验结果的概率。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BINOM.DIST.RANGE(trials,probability_s,number_s,[number_s2])</span><br></pre></td></tr></table></figure>

<h3 id="GAMMA-函数"><a href="#GAMMA-函数" class="headerlink" title="GAMMA 函数"></a>GAMMA 函数</h3><p>GAMMA 函数对于指定数值，返回其 GAMMA 函数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=GAMMA(number)</span><br><span class="line">=GAMMA(数字)</span><br></pre></td></tr></table></figure>

<h3 id="GAUSS-函数"><a href="#GAUSS-函数" class="headerlink" title="GAUSS 函数"></a>GAUSS 函数</h3><p>GAUSS 函数返回标准正态分布的比累积分布函数小 0.5 的值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=GAUSS(number)</span><br></pre></td></tr></table></figure>

<h3 id="PERMUTATIONA-函数"><a href="#PERMUTATIONA-函数" class="headerlink" title="PERMUTATIONA 函数"></a>PERMUTATIONA 函数</h3><p>PERMUTATIONA 函数返回从给定数目的对象中选取指定数量对象（含重复）的排列数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=PERMUTATIONA(number,number-chosen)</span><br><span class="line">=PERMUTATIONA(对象总数, 选取对象数量)</span><br></pre></td></tr></table></figure>

<h3 id="PHI-函数"><a href="#PHI-函数" class="headerlink" title="PHI 函数"></a>PHI 函数</h3><p>PHI 函数返回标准正态分布的密度函数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=PHI(x)</span><br></pre></td></tr></table></figure>

<h3 id="SKEW-P-函数"><a href="#SKEW-P-函数" class="headerlink" title="SKEW.P 函数"></a>SKEW.P 函数</h3><p>SKEW.P 函数返回基于样本总体分布的偏斜度。返回值为正数，表示正偏斜；返回值为负数，表示负偏斜。偏斜度表明分布相对于平均值的不对称程度。正偏斜度表明分布的不对称尾部趋向于更多正值。 负偏斜度表明分布的不对称尾部趋向于更多负值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=SKEW.P(number1, [number2], ...)</span><br><span class="line">=SKEW.P(数字1, [数字2], ...)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="文本函数"><a href="#文本函数" class="headerlink" title="文本函数"></a>文本函数</h2><h3 id="NUMBERVALUE-函数"><a href="#NUMBERVALUE-函数" class="headerlink" title="NUMBERVALUE 函数"></a>NUMBERVALUE 函数</h3><p>NUMBERVALUE 函数将文本以与区域设置无关的方式转换为数字。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=NUMBERVALUE(text, [decimal_separator], [group_separator])</span><br><span class="line">=NUMBERVALUE(文本, [整数小时分隔符], [组分隔符 ])</span><br></pre></td></tr></table></figure>

<h3 id="UNICHAR-函数"><a href="#UNICHAR-函数" class="headerlink" title="UNICHAR 函数"></a>UNICHAR 函数</h3><p>UNICHAR 函数返回给定数值引用的Unicode 字符。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=UNICHAR(number)</span><br><span class="line">=UNICHAR(数字)</span><br></pre></td></tr></table></figure>

<h3 id="UNICODE-函数"><a href="#UNICODE-函数" class="headerlink" title="UNICODE 函数"></a>UNICODE 函数</h3><p>UNICODE 函数返回对应于文本的第一个字符的数字代码。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=UNICODE(text)</span><br><span class="line">=UNICODE(文本)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="Web-函数"><a href="#Web-函数" class="headerlink" title="Web 函数"></a>Web 函数</h2><h3 id="ENCODEURL-函数"><a href="#ENCODEURL-函数" class="headerlink" title="ENCODEURL 函数"></a>ENCODEURL 函数</h3><p>ENCODEURL 函数返回 URL 编码的字符串。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=ENCODEURL（text)</span><br></pre></td></tr></table></figure>

<h3 id="FILTERXML-函数"><a href="#FILTERXML-函数" class="headerlink" title="FILTERXML 函数"></a>FILTERXML 函数</h3><p>FILTERXML 函数通过使用指定的 XPath，返回 XML 内容中的特定数据。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=FILTERXML(xml, xpath)</span><br></pre></td></tr></table></figure>

<h3 id="WEBSERVICE-函数"><a href="#WEBSERVICE-函数" class="headerlink" title="WEBSERVICE 函数"></a>WEBSERVICE 函数</h3><p>WEBSERVICE 函数从 Web 服务器返回数据。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=WEBSERVICE(url])</span><br></pre></td></tr></table></figure>

<p> </p>
<p> </p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2013-new-functions/" data-id="clatcwfab00f6xcq675af8zcu" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
    
<nav id="article-nav">
  
    <a href="/study-excel/excel-2013-more-chart-label/" id="article-nav-newer" class="article-nav-link-wrap">
      <strong class="article-nav-caption">Newer</strong>
      <div class="article-nav-title">
        
          Excel 2013 – 丰富的图表数据标签
        
      </div>
    </a>
  
  
    <a href="/study-excel/excel-2013-quick-chart-settings/" id="article-nav-older" class="article-nav-link-wrap">
      <strong class="article-nav-caption">Older</strong>
      <div class="article-nav-title">Excel 2013 – 新增快速设置图表格式工具</div>
    </a>
  
</nav>

  
</article>

</section>
        
          <aside id="sidebar">
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">分类</h3>
    <div class="widget">
      <ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/VBA/">VBA</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%85%AC%E5%BC%8F/">公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">公式基础</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E9%94%99%E8%AF%AF/">公式错误</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD/">功能</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F/">公式</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/">单元格引用</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E4%BD%BF%E7%94%A8-Excel/">使用 Excel</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F/">函数与公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%8D%95%E5%85%83%E6%A0%BC/">单元格</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E4%BF%9D%E5%AD%98%E8%AE%BE%E7%BD%AE/">保存设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E8%AE%BE%E7%BD%AE/">公式设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%B6%E4%BB%96%E8%AE%BE%E7%BD%AE/">其他设置</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/">复制公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/">审阅</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/">常见术语</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/">常规设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/">开始</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/">插入</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/">数据</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2007/">Excel 2007</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2016/">Excel 2016</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/">校对设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/">编写公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/">编辑公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/">视图</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/">页面布局</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/">高级设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/">鼠标指针</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/">打印</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/">查找与选择</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/">编辑单元格格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/">编辑工作表</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/">编辑工作表区域</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/">编辑数字格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/">鼠标操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%BF%AB%E6%8D%B7%E9%94%AE/">快捷键</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E9%97%AE%E9%A2%98/">问题</a></li></ul>
    </div>
  </div>


  
    

  
    
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">归档</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/study-excel/archives/2022/11/">十一月 2022</a></li></ul>
    </div>
  </div>


  
    
  <div class="widget-wrap">
    <h3 class="widget-title">最新文章</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/study-excel/excel-coupdaybs-function/">Excel COUPDAYBS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdays-function/">Excel COUPDAYS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdaysnc-function/">Excel COUPDAYSNC 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupncd-function/">Excel COUPNCD 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupnum-function/">Excel COUPNUM 函数</a>
          </li>
        
      </ul>
    </div>
  </div>

  
</aside>
        
      </div>
      <footer id="footer">
  
  <div class="outer">
    <div id="footer-info" class="inner">
      &copy; 2022 lijile<br>
      Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>
    </div>
    <nav id="mobile-nav">
  
    <a href="/study-excel/" class="mobile-nav-link">Home</a>
  
    <a href="/study-excel/archives" class="mobile-nav-link">Archives</a>
  
</nav>
    

<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>


  
<link rel="stylesheet" href="/study-excel/fancybox/jquery.fancybox.css">

  
<script src="/study-excel/fancybox/jquery.fancybox.pack.js"></script>




<script src="/study-excel/js/script.js"></script>




  </div>
</body>
</html>